﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Site_employees.Master" AutoEventWireup="true" CodeBehind="report_ticket2.aspx.cs" Inherits="Bus_proj.website.report_ticket2" %>
<%@ Register assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" namespace="Microsoft.Reporting.WebForms" tagprefix="rsweb" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:Bus_proConnectionString %>" 
        
    
    SelectCommand="SELECT Table_Sale.Sale_id, Table_Sale.Passenger_id, Table_Sale.Sale_date, Table_Sale.Sale_time, Table_Sale.Promotion_id, Table_Sale.Point_id, Table_Sale.Personnel_id, Table_Sale.Around_id, Table_Sale.SSID, Table_SaleDetail.Seat_id, Table_SaleDetail.Seat_no, Table_SaleDetail.Sale_id AS Expr1, Table_SaleDetail.Price_ticket, Table_SaleDetail.tex, Table_SaleDetail.Around_id AS Expr2, Table_Around.Around_id AS Expr3, Table_Around.Route_id, Table_Around.Around_date, Table_Around.Time_id, Table_Around.Bus_Line_id, Table_Around.Type_Bus_id, Table_Route.Route_id AS Expr4, Table_Route.Route_source, Table_Route.Route_destination, Table_Route.Route_distance, Table_Time.Time_id AS Expr5, Table_Time.Route_id AS Expr6, Table_Time.Time_time, Table_Type_Bus.Type_Bus_id AS Expr7, Table_Type_Bus.Type_Bus_name, Table_Type_Bus.Type_Bus_number, Table_Type_Bus.Type_Bus_seat_colum, Table_Type_Bus.Type_Bus_seat_row, Table_Promotion.Promotion_id AS Expr8, Table_Promotion.Promotion_name, Table_Promotion.Promotion_discount, Table_Promotion.Promotion_status, Table_Passenger.Passenger_name,  Table_Route.platform, Table_Category.Category_Discount FROM Table_Sale INNER JOIN Table_SaleDetail ON Table_Sale.Sale_id = Table_SaleDetail.Sale_id INNER JOIN Table_Around ON Table_Around.Around_id = Table_Sale.Around_id AND Table_SaleDetail.Around_id = Table_Around.Around_id INNER JOIN Table_Route ON Table_Route.Route_id = Table_Around.Route_id INNER JOIN Table_Time ON Table_Around.Time_id = Table_Time.Time_id INNER JOIN Table_Type_Bus ON Table_Type_Bus.Type_Bus_id = Table_Around.Type_Bus_id INNER JOIN Table_Promotion ON Table_Promotion.Promotion_id = Table_Sale.Promotion_id INNER JOIN Table_Passenger ON Table_Sale.Passenger_id = Table_Passenger.Passenger_id  INNER JOIN Table_Category ON Table_Passenger.Category_id = Table_Category.Category_id WHERE (Table_Sale.Sale_id = @e00) OR (Table_Sale.Sale_id = @e01) OR (Table_Sale.Sale_id = @e02) OR (Table_Sale.Sale_id = @e03) OR (Table_Sale.Sale_id = @e04) OR (Table_Sale.Sale_id = @e05) OR (Table_Sale.Sale_id = @e06) OR (Table_Sale.Sale_id = @e07) OR (Table_Sale.Sale_id = @e08) OR (Table_Sale.Sale_id = @e09) OR (Table_Sale.Sale_id = @e10) OR (Table_Sale.Sale_id = @e11) OR (Table_Sale.Sale_id = @e12) OR (Table_Sale.Sale_id = @e13) OR (Table_Sale.Sale_id = @e14) OR (Table_Sale.Sale_id = @e15) OR (Table_Sale.Sale_id = @e16) OR (Table_Sale.Sale_id = @e17) OR (Table_Sale.Sale_id = @e18) OR (Table_Sale.Sale_id = @e19) OR (Table_Sale.Sale_id = @e20)">
        <SelectParameters>
            <asp:SessionParameter DefaultValue="0" Name="e00" SessionField="0" />
            <asp:SessionParameter DefaultValue="0" Name="e01" SessionField="1" />
            <asp:SessionParameter DefaultValue="0" Name="e02" SessionField="2" />
            <asp:SessionParameter DefaultValue="0" Name="e03" SessionField="3" />
            <asp:SessionParameter DefaultValue="0" Name="e04" SessionField="4" />
            <asp:SessionParameter DefaultValue="0" Name="e05" SessionField="5" />
            <asp:SessionParameter DefaultValue="0" Name="e06" SessionField="6" />
            <asp:SessionParameter DefaultValue="0" Name="e07" SessionField="7" />
            <asp:SessionParameter DefaultValue="0" Name="e08" SessionField="8" />
            <asp:SessionParameter DefaultValue="0" Name="e09" SessionField="9" />
            <asp:SessionParameter DefaultValue="0" Name="e10" SessionField="10" />
            <asp:SessionParameter DefaultValue="0" Name="e11" SessionField="11" />
            <asp:SessionParameter DefaultValue="0" Name="e12" SessionField="12" />
            <asp:SessionParameter DefaultValue="0" Name="e13" SessionField="13" />
            <asp:SessionParameter DefaultValue="0" Name="e14" SessionField="14" />
            <asp:SessionParameter DefaultValue="0" Name="e15" SessionField="15" />
            <asp:SessionParameter DefaultValue="0" Name="e16" SessionField="16" />
            <asp:SessionParameter DefaultValue="0" Name="e17" SessionField="17" />
            <asp:SessionParameter DefaultValue="0" Name="e18" SessionField="18" />
            <asp:SessionParameter DefaultValue="0" Name="e19" SessionField="19" />
            <asp:SessionParameter DefaultValue="0" Name="e20" SessionField="20" />
        </SelectParameters>
    </asp:SqlDataSource>
    <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" 
    Font-Size="8pt" Height="462px" InteractiveDeviceInfos="(Collection)" 
    WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt" Width="644px">
        <localreport reportpath="website\Report_ticket_sale.rdlc">
            <datasources>
                <rsweb:ReportDataSource DataSourceId="SqlDataSource1" Name="DataSet1" />
            </datasources>
        </localreport>
</rsweb:ReportViewer>
</asp:Content>
